Senior Data Analyst
Würth
Creating analytical solutions for the Sales Support Director, Sales Director and CEO.
Tasked with problems when the established BI system (SAP BI) not adequate (too much data, unsupported charts etc.),
Using R and Spark for the data manipulation, subsequently producing advanced charts (d3.js, vega-lite.js, Plot.js, plotly, ggplot2), tables (AG Grid, Tabulator.js, reactable) and dashboards (Observable, Quarto).
For prototypes, using Excel with Power Pivot, DAX.
May 2022 - September 2024
Senior Risk Analyst
MND
Reporting directly to the board of directors.
Decision authority up to 200m CZK for credit limits.
Overseeing one junior colleague.
Market risk (VaR, MtM risk).
Credit risk (probability of default, credit assessments, exposure).
Granting approvals to algorithmic models and setting limits for them.
Creating/refining methodology and reporting for the above.
Using mainly R and Python.
September 2020 - April 2022
Senior Risk Manager
E.ON
Building complete credit risk reporting outside of ETRM (handling 600m row table), included credit report, broker report, what-if scenario calculator, used Oracle and R.
International project to set up Allegro ETRM locally, created market risk reports in Power BI.
January 2019 - August 2020
TOP & B2B Support
E.ON
VBA & SQL & R data wrangling (routinely working with millions of rows).
External data (ARES, RARIS, Magnus) acquisition.
Power Pivot & Power BI dashboards including DAX measures.
July 2017 - December 2018
E.ON Graduate Programme
E.ON
September 2015 - June 2017